Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 342645 |
| Missing cells | 54374 |
| Missing cells (%) | 1.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 36.6 MiB |
| Average record size in memory | 112.0 B |
Variable types
| Categorical | 1 |
|---|---|
| DateTime | 3 |
| Numeric | 9 |
| Text | 1 |
VERSIE has constant value "" | Constant |
DATUM_BESTAND has constant value "" | Constant |
PEILDATUM has constant value "" | Constant |
BEHANDELEND_SPECIALISME_CD is highly overall correlated with AANTAL_PAT_PER_SPC | High correlation |
AANTAL_PAT_PER_ZPD is highly overall correlated with AANTAL_SUBTRAJECT_PER_ZPD | High correlation |
AANTAL_SUBTRAJECT_PER_ZPD is highly overall correlated with AANTAL_PAT_PER_ZPD | High correlation |
AANTAL_PAT_PER_DIAG is highly overall correlated with AANTAL_SUBTRAJECT_PER_DIAG | High correlation |
AANTAL_SUBTRAJECT_PER_DIAG is highly overall correlated with AANTAL_PAT_PER_DIAG | High correlation |
AANTAL_PAT_PER_SPC is highly overall correlated with BEHANDELEND_SPECIALISME_CD and 1 other fields | High correlation |
AANTAL_SUBTRAJECT_PER_SPC is highly overall correlated with AANTAL_PAT_PER_SPC | High correlation |
GEMIDDELDE_VERKOOPPRIJS has 54374 (15.9%) missing values | Missing |
AANTAL_SUBTRAJECT_PER_ZPD is highly skewed (γ1 = 21.42121827) | Skewed |
Reproduction
| Analysis started | 2023-10-10 11:27:50.952755 |
|---|---|
| Analysis finished | 2023-10-10 11:28:20.505269 |
| Duration | 29.55 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
VERSIE
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1027935 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 342645 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 342645 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 342645 | |
| . | 342645 | |
| 0 | 342645 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 685290 | |
| Other Punctuation | 342645 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 342645 | |
| 0 | 342645 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 342645 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1027935 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 342645 | |
| . | 342645 | |
| 0 | 342645 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1027935 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 342645 | |
| . | 342645 | |
| 0 | 342645 |
DATUM_BESTAND
Date
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| Minimum | 2023-09-10 00:00:00 |
|---|---|
| Maximum | 2023-09-10 00:00:00 |
Histogram with fixed size bins (bins=1)
PEILDATUM
Date
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| Minimum | 2023-09-01 00:00:00 |
|---|---|
| Maximum | 2023-09-01 00:00:00 |
Histogram with fixed size bins (bins=1)
JAAR
Date
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| Minimum | 2012-01-01 00:00:00 |
|---|---|
| Maximum | 2023-01-01 00:00:00 |
Histogram with fixed size bins (bins=12)
BEHANDELEND_SPECIALISME_CD
Real number (ℝ)
HIGH CORRELATION
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 449.77818 |
| Minimum | 301 |
|---|---|
| Maximum | 8418 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 301 |
|---|---|
| 5-th percentile | 302 |
| Q1 | 305 |
| median | 313 |
| Q3 | 322 |
| 95-th percentile | 361 |
| Maximum | 8418 |
| Range | 8117 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 1034.1893 |
|---|---|
| Coefficient of variation (CV) | 2.2993319 |
| Kurtosis | 55.278205 |
| Mean | 449.77818 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 7.5633415 |
| Sum | 1.5411424 × 108 |
| Variance | 1069547.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 305 | 48065 | |
| 313 | 44540 | |
| 303 | 39400 | |
| 330 | 27082 | 7.9% |
| 316 | 23277 | 6.8% |
| 308 | 18412 | 5.4% |
| 306 | 14375 | 4.2% |
| 324 | 14059 | 4.1% |
| 301 | 13757 | 4.0% |
| 304 | 11175 | 3.3% |
| Other values (18) | 88503 |
| Value | Count | Frequency (%) |
| 301 | 13757 | 4.0% |
| 302 | 7534 | 2.2% |
| 303 | 39400 | |
| 304 | 11175 | 3.3% |
| 305 | 48065 | |
| 306 | 14375 | 4.2% |
| 307 | 6029 | 1.8% |
| 308 | 18412 | 5.4% |
| 310 | 3760 | 1.1% |
| 313 | 44540 |
| Value | Count | Frequency (%) |
| 8418 | 4650 | 1.4% |
| 8416 | 1017 | 0.3% |
| 1900 | 228 | 0.1% |
| 390 | 948 | 0.3% |
| 389 | 3599 | 1.1% |
| 362 | 4415 | 1.3% |
| 361 | 2472 | 0.7% |
| 335 | 3472 | 1.0% |
| 330 | 27082 | |
| 329 | 899 | 0.3% |
| Distinct | 1901 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.3522275 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1148624 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 9 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 99 |
|---|---|
| 2nd row | 14 |
| 3rd row | 02 |
| 4th row | 05 |
| 5th row | 13 |
| Value | Count | Frequency (%) |
| 101 | 1460 | 0.4% |
| 402 | 1412 | 0.4% |
| 301 | 1384 | 0.4% |
| 403 | 1379 | 0.4% |
| 201 | 1304 | 0.4% |
| 203 | 1282 | 0.4% |
| 401 | 1155 | 0.3% |
| 404 | 1141 | 0.3% |
| 409 | 1112 | 0.3% |
| 802 | 1108 | 0.3% |
| Other values (1891) | 329908 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 219569 | |
| 0 | 211086 | |
| 2 | 152259 | |
| 3 | 124332 | |
| 5 | 88527 | |
| 9 | 82753 | 7.2% |
| 4 | 81406 | 7.1% |
| 7 | 67627 | 5.9% |
| 6 | 59977 | 5.2% |
| 8 | 49455 | 4.3% |
| Other values (15) | 11633 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1136991 | |
| Uppercase Letter | 11633 | 1.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 2175 | |
| M | 1950 | |
| B | 1413 | |
| Z | 1003 | |
| E | 980 | |
| D | 765 | 6.6% |
| A | 754 | 6.5% |
| F | 725 | 6.2% |
| C | 380 | 3.3% |
| K | 377 | 3.2% |
| Other values (5) | 1111 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 219569 | |
| 0 | 211086 | |
| 2 | 152259 | |
| 3 | 124332 | |
| 5 | 88527 | |
| 9 | 82753 | 7.3% |
| 4 | 81406 | 7.2% |
| 7 | 67627 | 5.9% |
| 6 | 59977 | 5.3% |
| 8 | 49455 | 4.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1136991 | |
| Latin | 11633 | 1.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| G | 2175 | |
| M | 1950 | |
| B | 1413 | |
| Z | 1003 | |
| E | 980 | |
| D | 765 | 6.6% |
| A | 754 | 6.5% |
| F | 725 | 6.2% |
| C | 380 | 3.3% |
| K | 377 | 3.2% |
| Other values (5) | 1111 |
Common
| Value | Count | Frequency (%) |
| 1 | 219569 | |
| 0 | 211086 | |
| 2 | 152259 | |
| 3 | 124332 | |
| 5 | 88527 | |
| 9 | 82753 | 7.3% |
| 4 | 81406 | 7.2% |
| 7 | 67627 | 5.9% |
| 6 | 59977 | 5.3% |
| 8 | 49455 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1148624 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 219569 | |
| 0 | 211086 | |
| 2 | 152259 | |
| 3 | 124332 | |
| 5 | 88527 | |
| 9 | 82753 | 7.2% |
| 4 | 81406 | 7.1% |
| 7 | 67627 | 5.9% |
| 6 | 59977 | 5.2% |
| 8 | 49455 | 4.3% |
| Other values (15) | 11633 | 1.0% |
ZORGPRODUCT_CD
Real number (ℝ)
| Distinct | 6179 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.4033343 × 108 |
| Minimum | 10501002 |
|---|---|
| Maximum | 9.9841808 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 10501002 |
|---|---|
| 5-th percentile | 28999040 |
| Q1 | 99799058 |
| median | 1.4959903 × 108 |
| Q3 | 9.90004 × 108 |
| 95-th percentile | 9.9051605 × 108 |
| Maximum | 9.9841808 × 108 |
| Range | 9.8791708 × 108 |
| Interquartile range (IQR) | 8.9020494 × 108 |
Descriptive statistics
| Standard deviation | 4.2887002 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.97396651 |
| Kurtosis | -1.7351762 |
| Mean | 4.4033343 × 108 |
| Median Absolute Deviation (MAD) | 1.1960002 × 108 |
| Skewness | 0.46986069 |
| Sum | 1.5087805 × 1014 |
| Variance | 1.8392949 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 990004009 | 2526 | 0.7% |
| 990004007 | 2474 | 0.7% |
| 990003004 | 2353 | 0.7% |
| 990004006 | 1988 | 0.6% |
| 990356076 | 1830 | 0.5% |
| 990356073 | 1690 | 0.5% |
| 131999228 | 1680 | 0.5% |
| 131999164 | 1656 | 0.5% |
| 990003007 | 1534 | 0.4% |
| 131999194 | 1502 | 0.4% |
| Other values (6169) | 323412 |
| Value | Count | Frequency (%) |
| 10501002 | 9 | |
| 10501003 | 12 | |
| 10501004 | 12 | |
| 10501005 | 12 | |
| 10501007 | 3 | < 0.1% |
| 10501008 | 12 | |
| 10501010 | 12 | |
| 10501011 | 3 | < 0.1% |
| 11101002 | 11 | |
| 11101003 | 12 |
| Value | Count | Frequency (%) |
| 998418081 | 170 | |
| 998418080 | 154 | |
| 998418079 | 39 | < 0.1% |
| 998418077 | 9 | < 0.1% |
| 998418076 | 9 | < 0.1% |
| 998418075 | 7 | < 0.1% |
| 998418074 | 238 | |
| 998418073 | 240 | |
| 998418072 | 9 | < 0.1% |
| 998418071 | 9 | < 0.1% |
AANTAL_PAT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10395 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 510.68185 |
| Minimum | 1 |
|---|---|
| Maximum | 165184 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 13 |
| Q3 | 101 |
| 95-th percentile | 1718 |
| Maximum | 165184 |
| Range | 165183 |
| Interquartile range (IQR) | 98 |
Descriptive statistics
| Standard deviation | 3185.634 |
|---|---|
| Coefficient of variation (CV) | 6.2380012 |
| Kurtosis | 414.71829 |
| Mean | 510.68185 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 16.863148 |
| Sum | 1.7498258 × 108 |
| Variance | 10148264 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 57100 | 16.7% |
| 2 | 27817 | 8.1% |
| 3 | 18204 | 5.3% |
| 4 | 13252 | 3.9% |
| 5 | 10445 | 3.0% |
| 6 | 8789 | 2.6% |
| 7 | 7339 | 2.1% |
| 8 | 6160 | 1.8% |
| 9 | 5639 | 1.6% |
| 10 | 5024 | 1.5% |
| Other values (10385) | 182876 |
| Value | Count | Frequency (%) |
| 1 | 57100 | |
| 2 | 27817 | |
| 3 | 18204 | 5.3% |
| 4 | 13252 | 3.9% |
| 5 | 10445 | 3.0% |
| 6 | 8789 | 2.6% |
| 7 | 7339 | 2.1% |
| 8 | 6160 | 1.8% |
| 9 | 5639 | 1.6% |
| 10 | 5024 | 1.5% |
| Value | Count | Frequency (%) |
| 165184 | 1 | |
| 162459 | 1 | |
| 156552 | 1 | |
| 155870 | 1 | |
| 154483 | 1 | |
| 154259 | 1 | |
| 144715 | 1 | |
| 118396 | 1 | |
| 115935 | 1 | |
| 113246 | 1 |
AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 11168 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 605.42535 |
| Minimum | 1 |
|---|---|
| Maximum | 240002 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 14 |
| Q3 | 110 |
| 95-th percentile | 1963 |
| Maximum | 240002 |
| Range | 240001 |
| Interquartile range (IQR) | 107 |
Descriptive statistics
| Standard deviation | 4111.3164 |
|---|---|
| Coefficient of variation (CV) | 6.79079 |
| Kurtosis | 726.93634 |
| Mean | 605.42535 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 21.421218 |
| Sum | 2.0744597 × 108 |
| Variance | 16902923 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 55010 | 16.1% |
| 2 | 27342 | 8.0% |
| 3 | 18023 | 5.3% |
| 4 | 13043 | 3.8% |
| 5 | 10370 | 3.0% |
| 6 | 8761 | 2.6% |
| 7 | 7270 | 2.1% |
| 8 | 6107 | 1.8% |
| 9 | 5567 | 1.6% |
| 10 | 5018 | 1.5% |
| Other values (11158) | 186134 |
| Value | Count | Frequency (%) |
| 1 | 55010 | |
| 2 | 27342 | |
| 3 | 18023 | 5.3% |
| 4 | 13043 | 3.8% |
| 5 | 10370 | 3.0% |
| 6 | 8761 | 2.6% |
| 7 | 7270 | 2.1% |
| 8 | 6107 | 1.8% |
| 9 | 5567 | 1.6% |
| 10 | 5018 | 1.5% |
| Value | Count | Frequency (%) |
| 240002 | 1 | |
| 232423 | 1 | |
| 231954 | 1 | |
| 230940 | 1 | |
| 227936 | 1 | |
| 227409 | 1 | |
| 226321 | 1 | |
| 223891 | 1 | |
| 218673 | 1 | |
| 215132 | 1 |
AANTAL_PAT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 9294 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7653.6205 |
| Minimum | 1 |
|---|---|
| Maximum | 230640 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 38 |
| Q1 | 384 |
| median | 1675 |
| Q3 | 6204 |
| 95-th percentile | 36749 |
| Maximum | 230640 |
| Range | 230639 |
| Interquartile range (IQR) | 5820 |
Descriptive statistics
| Standard deviation | 17939.359 |
|---|---|
| Coefficient of variation (CV) | 2.343905 |
| Kurtosis | 34.83263 |
| Mean | 7653.6205 |
| Median Absolute Deviation (MAD) | 1534 |
| Skewness | 5.1117917 |
| Sum | 2.6224748 × 109 |
| Variance | 3.2182061 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 21 | 583 | 0.2% |
| 8 | 565 | 0.2% |
| 9 | 542 | 0.2% |
| 19 | 510 | 0.1% |
| 12 | 505 | 0.1% |
| 26 | 503 | 0.1% |
| 25 | 501 | 0.1% |
| 15 | 497 | 0.1% |
| 14 | 496 | 0.1% |
| 5 | 496 | 0.1% |
| Other values (9284) | 337447 |
| Value | Count | Frequency (%) |
| 1 | 442 | |
| 2 | 487 | |
| 3 | 474 | |
| 4 | 490 | |
| 5 | 496 | |
| 6 | 457 | |
| 7 | 493 | |
| 8 | 565 | |
| 9 | 542 | |
| 10 | 436 |
| Value | Count | Frequency (%) |
| 230640 | 23 | |
| 227999 | 23 | |
| 227310 | 19 | |
| 218429 | 24 | |
| 214507 | 17 | |
| 213516 | 25 | |
| 211579 | 17 | |
| 210416 | 19 | |
| 205338 | 17 | |
| 200600 | 16 |
AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10393 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11104.744 |
| Minimum | 1 |
|---|---|
| Maximum | 370140 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 48 |
| Q1 | 507 |
| median | 2333 |
| Q3 | 9025 |
| 95-th percentile | 52238 |
| Maximum | 370140 |
| Range | 370139 |
| Interquartile range (IQR) | 8518 |
Descriptive statistics
| Standard deviation | 26920.999 |
|---|---|
| Coefficient of variation (CV) | 2.4242791 |
| Kurtosis | 38.107923 |
| Mean | 11104.744 |
| Median Absolute Deviation (MAD) | 2152 |
| Skewness | 5.3410221 |
| Sum | 3.804985 × 109 |
| Variance | 7.2474018 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4 | 430 | 0.1% |
| 11 | 421 | 0.1% |
| 25 | 421 | 0.1% |
| 13 | 417 | 0.1% |
| 10 | 416 | 0.1% |
| 8 | 416 | 0.1% |
| 23 | 415 | 0.1% |
| 33 | 406 | 0.1% |
| 3 | 402 | 0.1% |
| 5 | 401 | 0.1% |
| Other values (10383) | 338500 |
| Value | Count | Frequency (%) |
| 1 | 361 | |
| 2 | 377 | |
| 3 | 402 | |
| 4 | 430 | |
| 5 | 401 | |
| 6 | 396 | |
| 7 | 389 | |
| 8 | 416 | |
| 9 | 342 | |
| 10 | 416 |
| Value | Count | Frequency (%) |
| 370140 | 23 | |
| 365354 | 23 | |
| 348485 | 25 | |
| 346189 | 19 | |
| 344333 | 24 | |
| 341653 | 19 | |
| 323756 | 20 | |
| 315771 | 17 | |
| 310754 | 17 | |
| 298627 | 17 |
AANTAL_PAT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 325 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 665442.76 |
| Minimum | 1610 |
|---|---|
| Maximum | 1487634 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1610 |
|---|---|
| 5-th percentile | 40186 |
| Q1 | 248733 |
| median | 765014 |
| Q3 | 1026304 |
| 95-th percentile | 1332331 |
| Maximum | 1487634 |
| Range | 1486024 |
| Interquartile range (IQR) | 777571 |
Descriptive statistics
| Standard deviation | 422451.07 |
|---|---|
| Coefficient of variation (CV) | 0.63484209 |
| Kurtosis | -1.1950283 |
| Mean | 665442.76 |
| Median Absolute Deviation (MAD) | 318423 |
| Skewness | -0.011052742 |
| Sum | 2.2801063 × 1011 |
| Variance | 1.7846491 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 880929 | 5102 | 1.5% |
| 874090 | 4354 | 1.3% |
| 843974 | 4347 | 1.3% |
| 894306 | 4333 | 1.3% |
| 880469 | 4273 | 1.2% |
| 897702 | 4212 | 1.2% |
| 765014 | 4089 | 1.2% |
| 803539 | 4027 | 1.2% |
| 775457 | 3978 | 1.2% |
| 1080758 | 3890 | 1.1% |
| Other values (315) | 300040 |
| Value | Count | Frequency (%) |
| 1610 | 130 | |
| 1829 | 138 | |
| 1920 | 131 | |
| 2032 | 72 | < 0.1% |
| 2495 | 173 | |
| 2520 | 190 | |
| 2592 | 62 | < 0.1% |
| 3737 | 279 | |
| 4096 | 166 | |
| 4765 | 80 | < 0.1% |
| Value | Count | Frequency (%) |
| 1487634 | 2975 | |
| 1450392 | 3048 | |
| 1421709 | 3564 | |
| 1344286 | 3543 | |
| 1340600 | 3441 | |
| 1332331 | 3545 | |
| 1316381 | 3463 | |
| 1282937 | 3576 | |
| 1267090 | 3350 | |
| 1265242 | 1177 | 0.3% |
AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 325 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1081195 |
| Minimum | 1861 |
|---|---|
| Maximum | 2664439 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1861 |
|---|---|
| 5-th percentile | 46325 |
| Q1 | 356291 |
| median | 1106921 |
| Q3 | 1776680 |
| 95-th percentile | 2548284 |
| Maximum | 2664439 |
| Range | 2662578 |
| Interquartile range (IQR) | 1420389 |
Descriptive statistics
| Standard deviation | 757875.73 |
|---|---|
| Coefficient of variation (CV) | 0.70096118 |
| Kurtosis | -0.85544451 |
| Mean | 1081195 |
| Median Absolute Deviation (MAD) | 703633 |
| Skewness | 0.34368238 |
| Sum | 3.7046606 × 1011 |
| Variance | 5.7437562 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1211794 | 5102 | 1.5% |
| 1281484 | 4354 | 1.3% |
| 1216251 | 4347 | 1.3% |
| 1315569 | 4333 | 1.3% |
| 1300433 | 4273 | 1.2% |
| 1341828 | 4212 | 1.2% |
| 1155933 | 4089 | 1.2% |
| 1205468 | 4027 | 1.2% |
| 1143059 | 3978 | 1.2% |
| 2548284 | 3890 | 1.1% |
| Other values (315) | 300040 |
| Value | Count | Frequency (%) |
| 1861 | 130 | |
| 2090 | 72 | < 0.1% |
| 2097 | 138 | |
| 2195 | 131 | |
| 2684 | 62 | < 0.1% |
| 2816 | 173 | |
| 3288 | 190 | |
| 3742 | 279 | |
| 4766 | 80 | < 0.1% |
| 4897 | 166 |
| Value | Count | Frequency (%) |
| 2664439 | 3866 | |
| 2663479 | 3793 | |
| 2618839 | 3789 | |
| 2593690 | 3844 | |
| 2548284 | 3890 | |
| 2480054 | 3851 | |
| 2469115 | 3880 | |
| 2178571 | 3757 | |
| 2062191 | 3811 | |
| 2052156 | 1168 | 0.3% |
GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)
MISSING
| Distinct | 3618 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 54374 |
| Missing (%) | 15.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3572.0718 |
| Minimum | 70 |
|---|---|
| Maximum | 287220 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 70 |
|---|---|
| 5-th percentile | 140 |
| Q1 | 475 |
| median | 1235 |
| Q3 | 4140 |
| 95-th percentile | 13520 |
| Maximum | 287220 |
| Range | 287150 |
| Interquartile range (IQR) | 3665 |
Descriptive statistics
| Standard deviation | 6515.0513 |
|---|---|
| Coefficient of variation (CV) | 1.8238859 |
| Kurtosis | 140.86348 |
| Mean | 3572.0718 |
| Median Absolute Deviation (MAD) | 1010 |
| Skewness | 7.070028 |
| Sum | 1.0297247 × 109 |
| Variance | 42445893 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 160 | 2149 | 0.6% |
| 105 | 1965 | 0.6% |
| 185 | 1800 | 0.5% |
| 110 | 1791 | 0.5% |
| 180 | 1619 | 0.5% |
| 175 | 1501 | 0.4% |
| 140 | 1493 | 0.4% |
| 300 | 1429 | 0.4% |
| 145 | 1371 | 0.4% |
| 125 | 1371 | 0.4% |
| Other values (3608) | 271782 | |
| (Missing) | 54374 | 15.9% |
| Value | Count | Frequency (%) |
| 70 | 226 | 0.1% |
| 75 | 75 | < 0.1% |
| 80 | 362 | 0.1% |
| 85 | 919 | |
| 90 | 664 | 0.2% |
| 95 | 734 | 0.2% |
| 100 | 1012 | |
| 105 | 1965 | |
| 110 | 1791 | |
| 115 | 1128 |
| Value | Count | Frequency (%) |
| 287220 | 8 | |
| 148910 | 3 | < 0.1% |
| 142835 | 4 | |
| 122155 | 4 | |
| 116765 | 3 | < 0.1% |
| 109725 | 7 | |
| 108570 | 7 | |
| 107655 | 4 | |
| 101270 | 8 | |
| 99590 | 5 |
| BEHANDELEND_SPECIALISME_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|
| BEHANDELEND_SPECIALISME_CD | 1.000 | 0.215 | 0.007 | 0.012 | -0.061 | -0.055 | -0.536 | -0.458 | 0.051 |
| ZORGPRODUCT_CD | 0.215 | 1.000 | -0.139 | -0.147 | -0.175 | -0.205 | -0.359 | -0.387 | 0.028 |
| AANTAL_PAT_PER_ZPD | 0.007 | -0.139 | 1.000 | 0.996 | 0.328 | 0.326 | 0.087 | 0.094 | -0.297 |
| AANTAL_SUBTRAJECT_PER_ZPD | 0.012 | -0.147 | 0.996 | 1.000 | 0.325 | 0.327 | 0.090 | 0.102 | -0.300 |
| AANTAL_PAT_PER_DIAG | -0.061 | -0.175 | 0.328 | 0.325 | 1.000 | 0.988 | 0.346 | 0.328 | 0.034 |
| AANTAL_SUBTRAJECT_PER_DIAG | -0.055 | -0.205 | 0.326 | 0.327 | 0.988 | 1.000 | 0.362 | 0.360 | 0.043 |
| AANTAL_PAT_PER_SPC | -0.536 | -0.359 | 0.087 | 0.090 | 0.346 | 0.362 | 1.000 | 0.963 | -0.004 |
| AANTAL_SUBTRAJECT_PER_SPC | -0.458 | -0.387 | 0.094 | 0.102 | 0.328 | 0.360 | 0.963 | 1.000 | -0.005 |
| GEMIDDELDE_VERKOOPPRIJS | 0.051 | 0.028 | -0.297 | -0.300 | 0.034 | 0.043 | -0.004 | -0.005 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| VERSIE | DATUM_BESTAND | PEILDATUM | JAAR | BEHANDELEND_SPECIALISME_CD | TYPERENDE_DIAGNOSE_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.0 | 2023-09-10 | 2023-09-01 | 2018-01-01 | 329 | 99 | 990029011 | 141 | 141 | 3708 | 3848 | 21981 | 24168 | 545.0 |
| 1 | 1.0 | 2023-09-10 | 2023-09-01 | 2018-01-01 | 329 | 14 | 990029010 | 4 | 4 | 97 | 97 | 21981 | 24168 | 1345.0 |
| 2 | 1.0 | 2023-09-10 | 2023-09-01 | 2018-01-01 | 329 | 02 | 990029011 | 1375 | 1386 | 4872 | 4977 | 21981 | 24168 | 545.0 |
| 3 | 1.0 | 2023-09-10 | 2023-09-01 | 2018-01-01 | 329 | 05 | 990029010 | 256 | 261 | 1285 | 1346 | 21981 | 24168 | 1345.0 |
| 4 | 1.0 | 2023-09-10 | 2023-09-01 | 2018-01-01 | 329 | 13 | 990029002 | 6 | 6 | 156 | 157 | 21981 | 24168 | 205.0 |
| 5 | 1.0 | 2023-09-10 | 2023-09-01 | 2018-01-01 | 329 | 07 | 990029011 | 676 | 690 | 1439 | 1500 | 21981 | 24168 | 545.0 |
| 6 | 1.0 | 2023-09-10 | 2023-09-01 | 2018-01-01 | 329 | 19 | 59899067 | 11 | 12 | 152 | 285 | 21981 | 24168 | 1440.0 |
| 7 | 1.0 | 2023-09-10 | 2023-09-01 | 2018-01-01 | 329 | 12 | 990029012 | 34 | 34 | 114 | 120 | 21981 | 24168 | 1040.0 |
| 8 | 1.0 | 2023-09-10 | 2023-09-01 | 2018-01-01 | 329 | 14 | 990029011 | 61 | 61 | 97 | 97 | 21981 | 24168 | 545.0 |
| 9 | 1.0 | 2023-09-10 | 2023-09-01 | 2018-01-01 | 329 | 10 | 990029002 | 14 | 14 | 93 | 99 | 21981 | 24168 | 205.0 |
| VERSIE | DATUM_BESTAND | PEILDATUM | JAAR | BEHANDELEND_SPECIALISME_CD | TYPERENDE_DIAGNOSE_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 342635 | 1.0 | 2023-09-10 | 2023-09-01 | 2014-01-01 | 303 | 413 | 99799008 | 3 | 3 | 217 | 242 | 1421709 | 1845606 | 1975.0 |
| 342636 | 1.0 | 2023-09-10 | 2023-09-01 | 2020-01-01 | 320 | 804 | 979001219 | 2 | 2 | 22933 | 40323 | 1030994 | 1831098 | 8335.0 |
| 342637 | 1.0 | 2023-09-10 | 2023-09-01 | 2020-01-01 | 313 | 842 | 29499004 | 2 | 2 | 5022 | 22342 | 1047048 | 2618839 | 9110.0 |
| 342638 | 1.0 | 2023-09-10 | 2023-09-01 | 2014-01-01 | 303 | 335 | 29199031 | 1 | 1 | 12848 | 17619 | 1421709 | 1845606 | 4125.0 |
| 342639 | 1.0 | 2023-09-10 | 2023-09-01 | 2020-01-01 | 313 | 020 | 131999154 | 2 | 2 | 3001 | 3805 | 1047048 | 2618839 | 965.0 |
| 342640 | 1.0 | 2023-09-10 | 2023-09-01 | 2020-01-01 | 313 | 434 | 79799011 | 1 | 1 | 342 | 494 | 1047048 | 2618839 | 2455.0 |
| 342641 | 1.0 | 2023-09-10 | 2023-09-01 | 2014-01-01 | 303 | 334 | 29199075 | 1 | 1 | 7963 | 9879 | 1421709 | 1845606 | 630.0 |
| 342642 | 1.0 | 2023-09-10 | 2023-09-01 | 2014-01-01 | 303 | 131 | 131999100 | 2 | 2 | 1920 | 2189 | 1421709 | 1845606 | 3605.0 |
| 342643 | 1.0 | 2023-09-10 | 2023-09-01 | 2014-01-01 | 303 | 249 | 199299067 | 1 | 1 | 884 | 958 | 1421709 | 1845606 | 2470.0 |
| 342644 | 1.0 | 2023-09-10 | 2023-09-01 | 2016-01-01 | 307 | M13 | 20108056 | 1 | 1 | 3259 | 6267 | 701349 | 1185655 | NaN |